本文展示在SQL SQL(2008版),使用遞迴方法正向展開BOM所有階層資料的預存程序做法
(A stored procedure program for forward spreading BOM using recursive method)
產品件號'2014009'的BOM結構:
(The BOM structure of product '2014009')
執行預存程序:
(Excuting stroed procedual 'usp_PDM_BOM_FOR_TREE')
EXEC usp_PDM_BOM_FOR_TREE '2014009'
輸出結果:
(Output)